{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤1 导入必要的库"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤2 从以下地址导入数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "path6 = \"./wind.data\"  # wind.data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤3 将数据作存储并且设置前三列为合适的索引"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yr</th>\n",
       "      <th>Mo</th>\n",
       "      <th>Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>13.21</td>\n",
       "      <td>8.12</td>\n",
       "      <td>9.96</td>\n",
       "      <td>6.67</td>\n",
       "      <td>5.37</td>\n",
       "      <td>4.50</td>\n",
       "      <td>10.67</td>\n",
       "      <td>4.42</td>\n",
       "      <td>7.17</td>\n",
       "      <td>7.50</td>\n",
       "      <td>8.12</td>\n",
       "      <td>13.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>13.50</td>\n",
       "      <td>14.29</td>\n",
       "      <td>9.50</td>\n",
       "      <td>4.96</td>\n",
       "      <td>12.29</td>\n",
       "      <td>8.33</td>\n",
       "      <td>9.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>7.58</td>\n",
       "      <td>7.96</td>\n",
       "      <td>13.96</td>\n",
       "      <td>13.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>10.96</td>\n",
       "      <td>9.75</td>\n",
       "      <td>7.62</td>\n",
       "      <td>5.91</td>\n",
       "      <td>9.62</td>\n",
       "      <td>7.29</td>\n",
       "      <td>14.29</td>\n",
       "      <td>7.62</td>\n",
       "      <td>9.25</td>\n",
       "      <td>10.46</td>\n",
       "      <td>16.62</td>\n",
       "      <td>16.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>12.58</td>\n",
       "      <td>10.83</td>\n",
       "      <td>10.00</td>\n",
       "      <td>4.75</td>\n",
       "      <td>10.37</td>\n",
       "      <td>6.79</td>\n",
       "      <td>8.04</td>\n",
       "      <td>10.13</td>\n",
       "      <td>7.79</td>\n",
       "      <td>9.08</td>\n",
       "      <td>13.04</td>\n",
       "      <td>15.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>13.37</td>\n",
       "      <td>11.12</td>\n",
       "      <td>19.50</td>\n",
       "      <td>8.33</td>\n",
       "      <td>9.71</td>\n",
       "      <td>6.54</td>\n",
       "      <td>11.42</td>\n",
       "      <td>7.79</td>\n",
       "      <td>8.54</td>\n",
       "      <td>9.00</td>\n",
       "      <td>8.58</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>10.58</td>\n",
       "      <td>9.87</td>\n",
       "      <td>8.42</td>\n",
       "      <td>2.79</td>\n",
       "      <td>8.71</td>\n",
       "      <td>7.25</td>\n",
       "      <td>7.54</td>\n",
       "      <td>8.33</td>\n",
       "      <td>5.71</td>\n",
       "      <td>8.67</td>\n",
       "      <td>20.71</td>\n",
       "      <td>16.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>19.75</td>\n",
       "      <td>12.08</td>\n",
       "      <td>18.50</td>\n",
       "      <td>10.54</td>\n",
       "      <td>10.29</td>\n",
       "      <td>9.46</td>\n",
       "      <td>15.54</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.37</td>\n",
       "      <td>14.58</td>\n",
       "      <td>15.59</td>\n",
       "      <td>14.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>9.92</td>\n",
       "      <td>3.54</td>\n",
       "      <td>8.46</td>\n",
       "      <td>2.96</td>\n",
       "      <td>2.29</td>\n",
       "      <td>0.96</td>\n",
       "      <td>4.63</td>\n",
       "      <td>0.58</td>\n",
       "      <td>2.33</td>\n",
       "      <td>3.37</td>\n",
       "      <td>5.25</td>\n",
       "      <td>7.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>9.04</td>\n",
       "      <td>5.66</td>\n",
       "      <td>7.08</td>\n",
       "      <td>0.67</td>\n",
       "      <td>2.71</td>\n",
       "      <td>1.38</td>\n",
       "      <td>3.08</td>\n",
       "      <td>2.58</td>\n",
       "      <td>0.50</td>\n",
       "      <td>2.67</td>\n",
       "      <td>7.17</td>\n",
       "      <td>5.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>12.04</td>\n",
       "      <td>9.67</td>\n",
       "      <td>11.75</td>\n",
       "      <td>2.37</td>\n",
       "      <td>7.38</td>\n",
       "      <td>3.13</td>\n",
       "      <td>2.50</td>\n",
       "      <td>6.83</td>\n",
       "      <td>4.75</td>\n",
       "      <td>5.63</td>\n",
       "      <td>7.54</td>\n",
       "      <td>6.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16.42</td>\n",
       "      <td>11.25</td>\n",
       "      <td>15.67</td>\n",
       "      <td>4.71</td>\n",
       "      <td>11.34</td>\n",
       "      <td>6.92</td>\n",
       "      <td>9.25</td>\n",
       "      <td>8.79</td>\n",
       "      <td>8.21</td>\n",
       "      <td>7.33</td>\n",
       "      <td>13.04</td>\n",
       "      <td>9.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>17.75</td>\n",
       "      <td>14.37</td>\n",
       "      <td>17.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>13.96</td>\n",
       "      <td>13.37</td>\n",
       "      <td>13.42</td>\n",
       "      <td>11.04</td>\n",
       "      <td>8.71</td>\n",
       "      <td>11.38</td>\n",
       "      <td>15.92</td>\n",
       "      <td>16.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>19.83</td>\n",
       "      <td>12.04</td>\n",
       "      <td>20.79</td>\n",
       "      <td>18.54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.29</td>\n",
       "      <td>17.83</td>\n",
       "      <td>11.38</td>\n",
       "      <td>14.67</td>\n",
       "      <td>16.71</td>\n",
       "      <td>8.79</td>\n",
       "      <td>17.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>4.92</td>\n",
       "      <td>3.42</td>\n",
       "      <td>7.29</td>\n",
       "      <td>1.04</td>\n",
       "      <td>3.67</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.71</td>\n",
       "      <td>2.79</td>\n",
       "      <td>1.92</td>\n",
       "      <td>2.71</td>\n",
       "      <td>6.87</td>\n",
       "      <td>7.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>9.59</td>\n",
       "      <td>11.83</td>\n",
       "      <td>7.96</td>\n",
       "      <td>1.58</td>\n",
       "      <td>7.92</td>\n",
       "      <td>5.00</td>\n",
       "      <td>3.17</td>\n",
       "      <td>4.92</td>\n",
       "      <td>3.13</td>\n",
       "      <td>3.37</td>\n",
       "      <td>6.50</td>\n",
       "      <td>6.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>14.33</td>\n",
       "      <td>10.25</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.13</td>\n",
       "      <td>10.04</td>\n",
       "      <td>7.67</td>\n",
       "      <td>8.04</td>\n",
       "      <td>9.17</td>\n",
       "      <td>7.04</td>\n",
       "      <td>7.87</td>\n",
       "      <td>6.75</td>\n",
       "      <td>12.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>9.59</td>\n",
       "      <td>5.88</td>\n",
       "      <td>9.92</td>\n",
       "      <td>2.17</td>\n",
       "      <td>6.87</td>\n",
       "      <td>5.50</td>\n",
       "      <td>9.38</td>\n",
       "      <td>7.04</td>\n",
       "      <td>6.34</td>\n",
       "      <td>7.50</td>\n",
       "      <td>10.88</td>\n",
       "      <td>9.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>16.54</td>\n",
       "      <td>9.96</td>\n",
       "      <td>18.54</td>\n",
       "      <td>10.46</td>\n",
       "      <td>13.50</td>\n",
       "      <td>12.67</td>\n",
       "      <td>13.70</td>\n",
       "      <td>13.75</td>\n",
       "      <td>10.75</td>\n",
       "      <td>13.17</td>\n",
       "      <td>14.79</td>\n",
       "      <td>20.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>25.04</td>\n",
       "      <td>14.83</td>\n",
       "      <td>25.84</td>\n",
       "      <td>15.67</td>\n",
       "      <td>21.46</td>\n",
       "      <td>18.58</td>\n",
       "      <td>20.38</td>\n",
       "      <td>19.38</td>\n",
       "      <td>15.37</td>\n",
       "      <td>15.12</td>\n",
       "      <td>23.09</td>\n",
       "      <td>25.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>13.62</td>\n",
       "      <td>11.17</td>\n",
       "      <td>12.67</td>\n",
       "      <td>6.04</td>\n",
       "      <td>10.00</td>\n",
       "      <td>9.42</td>\n",
       "      <td>9.25</td>\n",
       "      <td>8.71</td>\n",
       "      <td>7.12</td>\n",
       "      <td>12.04</td>\n",
       "      <td>14.04</td>\n",
       "      <td>17.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>24.37</td>\n",
       "      <td>18.79</td>\n",
       "      <td>17.50</td>\n",
       "      <td>14.25</td>\n",
       "      <td>18.91</td>\n",
       "      <td>15.67</td>\n",
       "      <td>14.33</td>\n",
       "      <td>15.16</td>\n",
       "      <td>16.08</td>\n",
       "      <td>19.08</td>\n",
       "      <td>20.50</td>\n",
       "      <td>25.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>22.04</td>\n",
       "      <td>20.79</td>\n",
       "      <td>17.41</td>\n",
       "      <td>16.21</td>\n",
       "      <td>19.04</td>\n",
       "      <td>16.13</td>\n",
       "      <td>16.79</td>\n",
       "      <td>18.29</td>\n",
       "      <td>18.66</td>\n",
       "      <td>19.08</td>\n",
       "      <td>26.08</td>\n",
       "      <td>27.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>17.67</td>\n",
       "      <td>13.54</td>\n",
       "      <td>13.33</td>\n",
       "      <td>8.87</td>\n",
       "      <td>15.04</td>\n",
       "      <td>11.63</td>\n",
       "      <td>12.25</td>\n",
       "      <td>10.58</td>\n",
       "      <td>11.92</td>\n",
       "      <td>11.04</td>\n",
       "      <td>20.30</td>\n",
       "      <td>18.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.91</td>\n",
       "      <td>22.29</td>\n",
       "      <td>17.54</td>\n",
       "      <td>24.08</td>\n",
       "      <td>19.70</td>\n",
       "      <td>22.00</td>\n",
       "      <td>20.25</td>\n",
       "      <td>21.46</td>\n",
       "      <td>19.95</td>\n",
       "      <td>27.71</td>\n",
       "      <td>23.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>12.21</td>\n",
       "      <td>11.42</td>\n",
       "      <td>10.92</td>\n",
       "      <td>7.92</td>\n",
       "      <td>13.08</td>\n",
       "      <td>9.62</td>\n",
       "      <td>14.50</td>\n",
       "      <td>10.21</td>\n",
       "      <td>9.92</td>\n",
       "      <td>11.96</td>\n",
       "      <td>18.88</td>\n",
       "      <td>19.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6544</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>13.70</td>\n",
       "      <td>12.71</td>\n",
       "      <td>14.29</td>\n",
       "      <td>5.13</td>\n",
       "      <td>9.21</td>\n",
       "      <td>8.04</td>\n",
       "      <td>12.33</td>\n",
       "      <td>6.34</td>\n",
       "      <td>9.21</td>\n",
       "      <td>11.21</td>\n",
       "      <td>9.59</td>\n",
       "      <td>19.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6545</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>21.21</td>\n",
       "      <td>21.34</td>\n",
       "      <td>17.75</td>\n",
       "      <td>11.58</td>\n",
       "      <td>16.75</td>\n",
       "      <td>14.46</td>\n",
       "      <td>17.46</td>\n",
       "      <td>15.29</td>\n",
       "      <td>15.79</td>\n",
       "      <td>17.50</td>\n",
       "      <td>21.42</td>\n",
       "      <td>25.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6546</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>9.92</td>\n",
       "      <td>13.50</td>\n",
       "      <td>7.21</td>\n",
       "      <td>1.71</td>\n",
       "      <td>11.00</td>\n",
       "      <td>7.50</td>\n",
       "      <td>8.38</td>\n",
       "      <td>7.46</td>\n",
       "      <td>10.79</td>\n",
       "      <td>10.21</td>\n",
       "      <td>17.88</td>\n",
       "      <td>17.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6547</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>22.75</td>\n",
       "      <td>20.17</td>\n",
       "      <td>18.58</td>\n",
       "      <td>8.50</td>\n",
       "      <td>15.96</td>\n",
       "      <td>14.29</td>\n",
       "      <td>13.92</td>\n",
       "      <td>12.92</td>\n",
       "      <td>12.96</td>\n",
       "      <td>12.29</td>\n",
       "      <td>17.08</td>\n",
       "      <td>19.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6548</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>29.33</td>\n",
       "      <td>23.87</td>\n",
       "      <td>25.37</td>\n",
       "      <td>16.04</td>\n",
       "      <td>24.46</td>\n",
       "      <td>19.50</td>\n",
       "      <td>24.54</td>\n",
       "      <td>18.58</td>\n",
       "      <td>21.00</td>\n",
       "      <td>20.58</td>\n",
       "      <td>21.67</td>\n",
       "      <td>34.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6549</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "      <td>26.63</td>\n",
       "      <td>24.79</td>\n",
       "      <td>24.79</td>\n",
       "      <td>18.16</td>\n",
       "      <td>23.13</td>\n",
       "      <td>19.58</td>\n",
       "      <td>19.92</td>\n",
       "      <td>19.04</td>\n",
       "      <td>19.75</td>\n",
       "      <td>21.50</td>\n",
       "      <td>23.04</td>\n",
       "      <td>34.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6550</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>12.92</td>\n",
       "      <td>12.54</td>\n",
       "      <td>11.25</td>\n",
       "      <td>3.37</td>\n",
       "      <td>6.50</td>\n",
       "      <td>5.96</td>\n",
       "      <td>10.34</td>\n",
       "      <td>6.17</td>\n",
       "      <td>6.63</td>\n",
       "      <td>6.75</td>\n",
       "      <td>9.54</td>\n",
       "      <td>17.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6551</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>18.71</td>\n",
       "      <td>16.92</td>\n",
       "      <td>15.50</td>\n",
       "      <td>6.04</td>\n",
       "      <td>10.37</td>\n",
       "      <td>9.59</td>\n",
       "      <td>10.75</td>\n",
       "      <td>9.13</td>\n",
       "      <td>9.75</td>\n",
       "      <td>11.08</td>\n",
       "      <td>14.33</td>\n",
       "      <td>15.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6552</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>24.92</td>\n",
       "      <td>22.54</td>\n",
       "      <td>16.54</td>\n",
       "      <td>14.62</td>\n",
       "      <td>15.59</td>\n",
       "      <td>13.00</td>\n",
       "      <td>13.21</td>\n",
       "      <td>14.12</td>\n",
       "      <td>16.21</td>\n",
       "      <td>16.17</td>\n",
       "      <td>26.08</td>\n",
       "      <td>21.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6553</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>20.25</td>\n",
       "      <td>19.17</td>\n",
       "      <td>17.83</td>\n",
       "      <td>11.63</td>\n",
       "      <td>17.79</td>\n",
       "      <td>13.37</td>\n",
       "      <td>14.83</td>\n",
       "      <td>13.88</td>\n",
       "      <td>15.54</td>\n",
       "      <td>16.29</td>\n",
       "      <td>18.34</td>\n",
       "      <td>22.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6554</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>23.13</td>\n",
       "      <td>18.63</td>\n",
       "      <td>18.05</td>\n",
       "      <td>8.29</td>\n",
       "      <td>14.33</td>\n",
       "      <td>11.04</td>\n",
       "      <td>10.54</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.42</td>\n",
       "      <td>10.50</td>\n",
       "      <td>11.25</td>\n",
       "      <td>13.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6555</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>18.84</td>\n",
       "      <td>24.04</td>\n",
       "      <td>14.37</td>\n",
       "      <td>8.33</td>\n",
       "      <td>18.12</td>\n",
       "      <td>12.17</td>\n",
       "      <td>13.00</td>\n",
       "      <td>13.75</td>\n",
       "      <td>14.17</td>\n",
       "      <td>15.09</td>\n",
       "      <td>21.50</td>\n",
       "      <td>21.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6556</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>17.21</td>\n",
       "      <td>19.75</td>\n",
       "      <td>12.71</td>\n",
       "      <td>5.83</td>\n",
       "      <td>13.79</td>\n",
       "      <td>7.33</td>\n",
       "      <td>8.83</td>\n",
       "      <td>5.71</td>\n",
       "      <td>7.96</td>\n",
       "      <td>3.37</td>\n",
       "      <td>5.21</td>\n",
       "      <td>6.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6557</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>13.13</td>\n",
       "      <td>8.92</td>\n",
       "      <td>16.54</td>\n",
       "      <td>6.92</td>\n",
       "      <td>6.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>12.67</td>\n",
       "      <td>5.88</td>\n",
       "      <td>7.67</td>\n",
       "      <td>6.08</td>\n",
       "      <td>5.50</td>\n",
       "      <td>17.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6558</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>14.88</td>\n",
       "      <td>9.13</td>\n",
       "      <td>17.37</td>\n",
       "      <td>5.21</td>\n",
       "      <td>6.71</td>\n",
       "      <td>2.46</td>\n",
       "      <td>9.13</td>\n",
       "      <td>4.96</td>\n",
       "      <td>6.13</td>\n",
       "      <td>5.96</td>\n",
       "      <td>10.92</td>\n",
       "      <td>18.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6559</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "      <td>9.87</td>\n",
       "      <td>3.21</td>\n",
       "      <td>8.04</td>\n",
       "      <td>2.21</td>\n",
       "      <td>3.04</td>\n",
       "      <td>0.54</td>\n",
       "      <td>2.46</td>\n",
       "      <td>1.46</td>\n",
       "      <td>1.29</td>\n",
       "      <td>2.67</td>\n",
       "      <td>5.00</td>\n",
       "      <td>9.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6560</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>9.83</td>\n",
       "      <td>10.88</td>\n",
       "      <td>8.50</td>\n",
       "      <td>1.00</td>\n",
       "      <td>9.08</td>\n",
       "      <td>6.00</td>\n",
       "      <td>2.42</td>\n",
       "      <td>8.25</td>\n",
       "      <td>4.42</td>\n",
       "      <td>5.88</td>\n",
       "      <td>19.79</td>\n",
       "      <td>19.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6561</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>13.88</td>\n",
       "      <td>11.42</td>\n",
       "      <td>10.13</td>\n",
       "      <td>2.33</td>\n",
       "      <td>8.12</td>\n",
       "      <td>6.75</td>\n",
       "      <td>4.75</td>\n",
       "      <td>5.88</td>\n",
       "      <td>6.21</td>\n",
       "      <td>8.17</td>\n",
       "      <td>8.33</td>\n",
       "      <td>18.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6562</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>9.92</td>\n",
       "      <td>3.63</td>\n",
       "      <td>12.38</td>\n",
       "      <td>3.08</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.42</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2.13</td>\n",
       "      <td>4.71</td>\n",
       "      <td>3.21</td>\n",
       "      <td>10.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6563</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>12.96</td>\n",
       "      <td>3.83</td>\n",
       "      <td>13.79</td>\n",
       "      <td>4.79</td>\n",
       "      <td>7.12</td>\n",
       "      <td>6.54</td>\n",
       "      <td>11.67</td>\n",
       "      <td>9.25</td>\n",
       "      <td>8.67</td>\n",
       "      <td>9.00</td>\n",
       "      <td>11.25</td>\n",
       "      <td>20.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6564</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>6.21</td>\n",
       "      <td>7.38</td>\n",
       "      <td>13.08</td>\n",
       "      <td>2.54</td>\n",
       "      <td>7.58</td>\n",
       "      <td>5.33</td>\n",
       "      <td>2.46</td>\n",
       "      <td>8.38</td>\n",
       "      <td>5.09</td>\n",
       "      <td>5.04</td>\n",
       "      <td>9.92</td>\n",
       "      <td>11.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6565</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>16.62</td>\n",
       "      <td>13.29</td>\n",
       "      <td>22.21</td>\n",
       "      <td>9.50</td>\n",
       "      <td>14.29</td>\n",
       "      <td>13.08</td>\n",
       "      <td>16.50</td>\n",
       "      <td>17.16</td>\n",
       "      <td>12.71</td>\n",
       "      <td>12.00</td>\n",
       "      <td>18.50</td>\n",
       "      <td>21.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6566</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>8.67</td>\n",
       "      <td>5.63</td>\n",
       "      <td>12.12</td>\n",
       "      <td>4.79</td>\n",
       "      <td>5.09</td>\n",
       "      <td>5.91</td>\n",
       "      <td>12.25</td>\n",
       "      <td>9.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>11.71</td>\n",
       "      <td>11.92</td>\n",
       "      <td>31.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6567</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>7.21</td>\n",
       "      <td>6.58</td>\n",
       "      <td>7.83</td>\n",
       "      <td>2.67</td>\n",
       "      <td>4.79</td>\n",
       "      <td>4.58</td>\n",
       "      <td>8.71</td>\n",
       "      <td>0.75</td>\n",
       "      <td>5.21</td>\n",
       "      <td>5.25</td>\n",
       "      <td>1.21</td>\n",
       "      <td>13.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6568</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>26</td>\n",
       "      <td>13.83</td>\n",
       "      <td>11.87</td>\n",
       "      <td>10.34</td>\n",
       "      <td>2.37</td>\n",
       "      <td>6.96</td>\n",
       "      <td>4.29</td>\n",
       "      <td>1.96</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.04</td>\n",
       "      <td>3.08</td>\n",
       "      <td>4.79</td>\n",
       "      <td>11.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6569</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>27</td>\n",
       "      <td>17.58</td>\n",
       "      <td>16.96</td>\n",
       "      <td>17.62</td>\n",
       "      <td>8.08</td>\n",
       "      <td>13.21</td>\n",
       "      <td>11.67</td>\n",
       "      <td>14.46</td>\n",
       "      <td>15.59</td>\n",
       "      <td>14.04</td>\n",
       "      <td>14.00</td>\n",
       "      <td>17.21</td>\n",
       "      <td>40.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6570</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>13.21</td>\n",
       "      <td>5.46</td>\n",
       "      <td>13.46</td>\n",
       "      <td>5.00</td>\n",
       "      <td>8.12</td>\n",
       "      <td>9.42</td>\n",
       "      <td>14.33</td>\n",
       "      <td>16.25</td>\n",
       "      <td>15.25</td>\n",
       "      <td>18.05</td>\n",
       "      <td>21.79</td>\n",
       "      <td>41.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6571</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>29</td>\n",
       "      <td>14.00</td>\n",
       "      <td>10.29</td>\n",
       "      <td>14.42</td>\n",
       "      <td>8.71</td>\n",
       "      <td>9.71</td>\n",
       "      <td>10.54</td>\n",
       "      <td>19.17</td>\n",
       "      <td>12.46</td>\n",
       "      <td>14.50</td>\n",
       "      <td>16.42</td>\n",
       "      <td>18.88</td>\n",
       "      <td>29.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6572</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>18.50</td>\n",
       "      <td>14.04</td>\n",
       "      <td>21.29</td>\n",
       "      <td>9.13</td>\n",
       "      <td>12.75</td>\n",
       "      <td>9.71</td>\n",
       "      <td>18.08</td>\n",
       "      <td>12.87</td>\n",
       "      <td>12.46</td>\n",
       "      <td>12.12</td>\n",
       "      <td>14.67</td>\n",
       "      <td>28.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6573</th>\n",
       "      <td>78</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>20.33</td>\n",
       "      <td>17.41</td>\n",
       "      <td>27.29</td>\n",
       "      <td>9.59</td>\n",
       "      <td>12.08</td>\n",
       "      <td>10.13</td>\n",
       "      <td>19.25</td>\n",
       "      <td>11.63</td>\n",
       "      <td>11.58</td>\n",
       "      <td>11.38</td>\n",
       "      <td>12.08</td>\n",
       "      <td>22.08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6574 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Yr  Mo  Dy    RPT    VAL    ROS    KIL    SHA    BIR    DUB    CLA  \\\n",
       "0     61   1   1  15.04  14.96  13.17   9.29    NaN   9.87  13.67  10.25   \n",
       "1     61   1   2  14.71    NaN  10.83   6.50  12.62   7.67  11.50  10.04   \n",
       "2     61   1   3  18.50  16.88  12.33  10.13  11.17   6.17  11.25    NaN   \n",
       "3     61   1   4  10.58   6.63  11.75   4.58   4.54   2.88   8.63   1.79   \n",
       "4     61   1   5  13.33  13.25  11.42   6.17  10.71   8.21  11.92   6.54   \n",
       "5     61   1   6  13.21   8.12   9.96   6.67   5.37   4.50  10.67   4.42   \n",
       "6     61   1   7  13.50  14.29   9.50   4.96  12.29   8.33   9.17   9.29   \n",
       "7     61   1   8  10.96   9.75   7.62   5.91   9.62   7.29  14.29   7.62   \n",
       "8     61   1   9  12.58  10.83  10.00   4.75  10.37   6.79   8.04  10.13   \n",
       "9     61   1  10  13.37  11.12  19.50   8.33   9.71   6.54  11.42   7.79   \n",
       "10    61   1  11  10.58   9.87   8.42   2.79   8.71   7.25   7.54   8.33   \n",
       "11    61   1  12  19.75  12.08  18.50  10.54  10.29   9.46  15.54  11.50   \n",
       "12    61   1  13   9.92   3.54   8.46   2.96   2.29   0.96   4.63   0.58   \n",
       "13    61   1  14   9.04   5.66   7.08   0.67   2.71   1.38   3.08   2.58   \n",
       "14    61   1  15  12.04   9.67  11.75   2.37   7.38   3.13   2.50   6.83   \n",
       "15    61   1  16  16.42  11.25  15.67   4.71  11.34   6.92   9.25   8.79   \n",
       "16    61   1  17  17.75  14.37  17.33  10.13  13.96  13.37  13.42  11.04   \n",
       "17    61   1  18  19.83  12.04  20.79  18.54    NaN  10.29  17.83  11.38   \n",
       "18    61   1  19   4.92   3.42   7.29   1.04   3.67   3.17   3.71   2.79   \n",
       "19    61   1  20   9.59  11.83   7.96   1.58   7.92   5.00   3.17   4.92   \n",
       "20    61   1  21  14.33  10.25  11.92   6.13  10.04   7.67   8.04   9.17   \n",
       "21    61   1  22   9.59   5.88   9.92   2.17   6.87   5.50   9.38   7.04   \n",
       "22    61   1  23  16.54   9.96  18.54  10.46  13.50  12.67  13.70  13.75   \n",
       "23    61   1  24  25.04  14.83  25.84  15.67  21.46  18.58  20.38  19.38   \n",
       "24    61   1  25  13.62  11.17  12.67   6.04  10.00   9.42   9.25   8.71   \n",
       "25    61   1  26  24.37  18.79  17.50  14.25  18.91  15.67  14.33  15.16   \n",
       "26    61   1  27  22.04  20.79  17.41  16.21  19.04  16.13  16.79  18.29   \n",
       "27    61   1  28  17.67  13.54  13.33   8.87  15.04  11.63  12.25  10.58   \n",
       "28    61   1  29    NaN  23.91  22.29  17.54  24.08  19.70  22.00  20.25   \n",
       "29    61   1  30  12.21  11.42  10.92   7.92  13.08   9.62  14.50  10.21   \n",
       "...   ..  ..  ..    ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "6544  78  12   2  13.70  12.71  14.29   5.13   9.21   8.04  12.33   6.34   \n",
       "6545  78  12   3  21.21  21.34  17.75  11.58  16.75  14.46  17.46  15.29   \n",
       "6546  78  12   4   9.92  13.50   7.21   1.71  11.00   7.50   8.38   7.46   \n",
       "6547  78  12   5  22.75  20.17  18.58   8.50  15.96  14.29  13.92  12.92   \n",
       "6548  78  12   6  29.33  23.87  25.37  16.04  24.46  19.50  24.54  18.58   \n",
       "6549  78  12   7  26.63  24.79  24.79  18.16  23.13  19.58  19.92  19.04   \n",
       "6550  78  12   8  12.92  12.54  11.25   3.37   6.50   5.96  10.34   6.17   \n",
       "6551  78  12   9  18.71  16.92  15.50   6.04  10.37   9.59  10.75   9.13   \n",
       "6552  78  12  10  24.92  22.54  16.54  14.62  15.59  13.00  13.21  14.12   \n",
       "6553  78  12  11  20.25  19.17  17.83  11.63  17.79  13.37  14.83  13.88   \n",
       "6554  78  12  12  23.13  18.63  18.05   8.29  14.33  11.04  10.54  10.13   \n",
       "6555  78  12  13  18.84  24.04  14.37   8.33  18.12  12.17  13.00  13.75   \n",
       "6556  78  12  14  17.21  19.75  12.71   5.83  13.79   7.33   8.83   5.71   \n",
       "6557  78  12  15  13.13   8.92  16.54   6.92   6.00   4.00  12.67   5.88   \n",
       "6558  78  12  16  14.88   9.13  17.37   5.21   6.71   2.46   9.13   4.96   \n",
       "6559  78  12  17   9.87   3.21   8.04   2.21   3.04   0.54   2.46   1.46   \n",
       "6560  78  12  18   9.83  10.88   8.50   1.00   9.08   6.00   2.42   8.25   \n",
       "6561  78  12  19  13.88  11.42  10.13   2.33   8.12   6.75   4.75   5.88   \n",
       "6562  78  12  20   9.92   3.63  12.38   3.08   3.50   0.42   4.54   2.50   \n",
       "6563  78  12  21  12.96   3.83  13.79   4.79   7.12   6.54  11.67   9.25   \n",
       "6564  78  12  22   6.21   7.38  13.08   2.54   7.58   5.33   2.46   8.38   \n",
       "6565  78  12  23  16.62  13.29  22.21   9.50  14.29  13.08  16.50  17.16   \n",
       "6566  78  12  24   8.67   5.63  12.12   4.79   5.09   5.91  12.25   9.25   \n",
       "6567  78  12  25   7.21   6.58   7.83   2.67   4.79   4.58   8.71   0.75   \n",
       "6568  78  12  26  13.83  11.87  10.34   2.37   6.96   4.29   1.96   3.79   \n",
       "6569  78  12  27  17.58  16.96  17.62   8.08  13.21  11.67  14.46  15.59   \n",
       "6570  78  12  28  13.21   5.46  13.46   5.00   8.12   9.42  14.33  16.25   \n",
       "6571  78  12  29  14.00  10.29  14.42   8.71   9.71  10.54  19.17  12.46   \n",
       "6572  78  12  30  18.50  14.04  21.29   9.13  12.75   9.71  18.08  12.87   \n",
       "6573  78  12  31  20.33  17.41  27.29   9.59  12.08  10.13  19.25  11.63   \n",
       "\n",
       "        MUL    CLO    BEL    MAL  \n",
       "0     10.83  12.58  18.50  15.04  \n",
       "1      9.79   9.67  17.54  13.83  \n",
       "2      8.50   7.67  12.75  12.71  \n",
       "3      5.83   5.88   5.46  10.88  \n",
       "4     10.92  10.34  12.92  11.83  \n",
       "5      7.17   7.50   8.12  13.17  \n",
       "6      7.58   7.96  13.96  13.79  \n",
       "7      9.25  10.46  16.62  16.46  \n",
       "8      7.79   9.08  13.04  15.37  \n",
       "9      8.54   9.00   8.58  11.83  \n",
       "10     5.71   8.67  20.71  16.92  \n",
       "11    10.37  14.58  15.59  14.09  \n",
       "12     2.33   3.37   5.25   7.04  \n",
       "13     0.50   2.67   7.17   5.17  \n",
       "14     4.75   5.63   7.54   6.75  \n",
       "15     8.21   7.33  13.04   9.04  \n",
       "16     8.71  11.38  15.92  16.08  \n",
       "17    14.67  16.71   8.79  17.96  \n",
       "18     1.92   2.71   6.87   7.83  \n",
       "19     3.13   3.37   6.50   6.79  \n",
       "20     7.04   7.87   6.75  12.42  \n",
       "21     6.34   7.50  10.88   9.92  \n",
       "22    10.75  13.17  14.79  20.58  \n",
       "23    15.37  15.12  23.09  25.25  \n",
       "24     7.12  12.04  14.04  17.50  \n",
       "25    16.08  19.08  20.50  25.25  \n",
       "26    18.66  19.08  26.08  27.63  \n",
       "27    11.92  11.04  20.30  18.12  \n",
       "28    21.46  19.95  27.71  23.38  \n",
       "29     9.92  11.96  18.88  19.25  \n",
       "...     ...    ...    ...    ...  \n",
       "6544   9.21  11.21   9.59  19.95  \n",
       "6545  15.79  17.50  21.42  25.75  \n",
       "6546  10.79  10.21  17.88  17.96  \n",
       "6547  12.96  12.29  17.08  19.83  \n",
       "6548  21.00  20.58  21.67  34.46  \n",
       "6549  19.75  21.50  23.04  34.59  \n",
       "6550   6.63   6.75   9.54  17.33  \n",
       "6551   9.75  11.08  14.33  15.34  \n",
       "6552  16.21  16.17  26.08  21.92  \n",
       "6553  15.54  16.29  18.34  22.83  \n",
       "6554  11.42  10.50  11.25  13.50  \n",
       "6555  14.17  15.09  21.50  21.37  \n",
       "6556   7.96   3.37   5.21   6.92  \n",
       "6557   7.67   6.08   5.50  17.16  \n",
       "6558   6.13   5.96  10.92  18.08  \n",
       "6559   1.29   2.67   5.00   9.08  \n",
       "6560   4.42   5.88  19.79  19.79  \n",
       "6561   6.21   8.17   8.33  18.25  \n",
       "6562   2.13   4.71   3.21  10.29  \n",
       "6563   8.67   9.00  11.25  20.30  \n",
       "6564   5.09   5.04   9.92  11.00  \n",
       "6565  12.71  12.00  18.50  21.50  \n",
       "6566  10.83  11.71  11.92  31.71  \n",
       "6567   5.21   5.25   1.21  13.96  \n",
       "6568   3.04   3.08   4.79  11.96  \n",
       "6569  14.04  14.00  17.21  40.08  \n",
       "6570  15.25  18.05  21.79  41.46  \n",
       "6571  14.50  16.42  18.88  29.58  \n",
       "6572  12.46  12.12  14.67  28.79  \n",
       "6573  11.58  11.38  12.08  22.08  \n",
       "\n",
       "[6574 rows x 15 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_table(path6, sep='\\s+')\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤4 2061年？我们真的有这一年的数据？创建一个函数并用它去修复这个bug"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1961-01-01</td>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1961-01-02</td>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1961-01-03</td>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1961-01-04</td>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1961-01-05</td>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Yr_Mo_Dy    RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "0  1961-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1  1961-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "2  1961-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "3  1961-01-04  10.58   6.63  11.75   4.58   4.54  2.88   8.63   1.79   5.83   \n",
       "4  1961-01-05  13.33  13.25  11.42   6.17  10.71  8.21  11.92   6.54  10.92   \n",
       "\n",
       "     CLO    BEL    MAL  \n",
       "0  12.58  18.50  15.04  \n",
       "1   9.67  17.54  13.83  \n",
       "2   7.67  12.75  12.71  \n",
       "3   5.88   5.46  10.88  \n",
       "4  10.34  12.92  11.83  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤5 将日期设为索引，注意数据类型，应该是```datetime64[ns]```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr_Mo_Dy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1961-01-01</th>\n",
       "      <td>15.04</td>\n",
       "      <td>14.96</td>\n",
       "      <td>13.17</td>\n",
       "      <td>9.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.87</td>\n",
       "      <td>13.67</td>\n",
       "      <td>10.25</td>\n",
       "      <td>10.83</td>\n",
       "      <td>12.58</td>\n",
       "      <td>18.50</td>\n",
       "      <td>15.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-02</th>\n",
       "      <td>14.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>6.50</td>\n",
       "      <td>12.62</td>\n",
       "      <td>7.67</td>\n",
       "      <td>11.50</td>\n",
       "      <td>10.04</td>\n",
       "      <td>9.79</td>\n",
       "      <td>9.67</td>\n",
       "      <td>17.54</td>\n",
       "      <td>13.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-03</th>\n",
       "      <td>18.50</td>\n",
       "      <td>16.88</td>\n",
       "      <td>12.33</td>\n",
       "      <td>10.13</td>\n",
       "      <td>11.17</td>\n",
       "      <td>6.17</td>\n",
       "      <td>11.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.50</td>\n",
       "      <td>7.67</td>\n",
       "      <td>12.75</td>\n",
       "      <td>12.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-04</th>\n",
       "      <td>10.58</td>\n",
       "      <td>6.63</td>\n",
       "      <td>11.75</td>\n",
       "      <td>4.58</td>\n",
       "      <td>4.54</td>\n",
       "      <td>2.88</td>\n",
       "      <td>8.63</td>\n",
       "      <td>1.79</td>\n",
       "      <td>5.83</td>\n",
       "      <td>5.88</td>\n",
       "      <td>5.46</td>\n",
       "      <td>10.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1961-01-05</th>\n",
       "      <td>13.33</td>\n",
       "      <td>13.25</td>\n",
       "      <td>11.42</td>\n",
       "      <td>6.17</td>\n",
       "      <td>10.71</td>\n",
       "      <td>8.21</td>\n",
       "      <td>11.92</td>\n",
       "      <td>6.54</td>\n",
       "      <td>10.92</td>\n",
       "      <td>10.34</td>\n",
       "      <td>12.92</td>\n",
       "      <td>11.83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              RPT    VAL    ROS    KIL    SHA   BIR    DUB    CLA    MUL  \\\n",
       "Yr_Mo_Dy                                                                   \n",
       "1961-01-01  15.04  14.96  13.17   9.29    NaN  9.87  13.67  10.25  10.83   \n",
       "1961-01-02  14.71    NaN  10.83   6.50  12.62  7.67  11.50  10.04   9.79   \n",
       "1961-01-03  18.50  16.88  12.33  10.13  11.17  6.17  11.25    NaN   8.50   \n",
       "1961-01-04  10.58   6.63  11.75   4.58   4.54  2.88   8.63   1.79   5.83   \n",
       "1961-01-05  13.33  13.25  11.42   6.17  10.71  8.21  11.92   6.54  10.92   \n",
       "\n",
       "              CLO    BEL    MAL  \n",
       "Yr_Mo_Dy                         \n",
       "1961-01-01  12.58  18.50  15.04  \n",
       "1961-01-02   9.67  17.54  13.83  \n",
       "1961-01-03   7.67  12.75  12.71  \n",
       "1961-01-04   5.88   5.46  10.88  \n",
       "1961-01-05  10.34  12.92  11.83  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤6 对应每一个location，一共有多少数据值缺失"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤7 对应每一个location，一共有多少完整的数据值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Yr     15\n",
       "Mo     15\n",
       "Dy     15\n",
       "RPT     9\n",
       "VAL    12\n",
       "ROS    13\n",
       "KIL    10\n",
       "SHA    13\n",
       "BIR    15\n",
       "DUB    12\n",
       "CLA    13\n",
       "MUL    12\n",
       "CLO    14\n",
       "BEL    15\n",
       "MAL    11\n",
       "dtype: int64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤8 对于全体数据，计算风速的平均值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10.227982360836924"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤9 创建一个名为```loc_stats```的数据框去计算并存储每个location的风速最小值，最大值，平均值和标准差"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤10 创建一个名为```day_stats```的数据框去计算并存储所有location的风速最小值，最大值，平均值和标准差"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤11 对于每一个location，计算各月份的平均风速\n",
    "*注意，不同年份的同一月份（如1961年的1月和1962年的1月）应该区别对待*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yr</th>\n",
       "      <th>Mo</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"12\" valign=\"top\">61</th>\n",
       "      <th>1</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.841333</td>\n",
       "      <td>11.988333</td>\n",
       "      <td>13.431613</td>\n",
       "      <td>7.736774</td>\n",
       "      <td>11.072759</td>\n",
       "      <td>8.588065</td>\n",
       "      <td>11.184839</td>\n",
       "      <td>9.245333</td>\n",
       "      <td>9.085806</td>\n",
       "      <td>10.107419</td>\n",
       "      <td>13.880968</td>\n",
       "      <td>14.703226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.5</td>\n",
       "      <td>16.269286</td>\n",
       "      <td>14.975357</td>\n",
       "      <td>14.441481</td>\n",
       "      <td>9.230741</td>\n",
       "      <td>13.852143</td>\n",
       "      <td>10.937500</td>\n",
       "      <td>11.890714</td>\n",
       "      <td>11.846071</td>\n",
       "      <td>11.821429</td>\n",
       "      <td>12.714286</td>\n",
       "      <td>18.583214</td>\n",
       "      <td>15.411786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16.0</td>\n",
       "      <td>10.890000</td>\n",
       "      <td>11.296452</td>\n",
       "      <td>10.752903</td>\n",
       "      <td>7.284000</td>\n",
       "      <td>10.509355</td>\n",
       "      <td>8.866774</td>\n",
       "      <td>9.644194</td>\n",
       "      <td>9.829677</td>\n",
       "      <td>10.294138</td>\n",
       "      <td>11.251935</td>\n",
       "      <td>16.410968</td>\n",
       "      <td>15.720000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.5</td>\n",
       "      <td>10.722667</td>\n",
       "      <td>9.427667</td>\n",
       "      <td>9.998000</td>\n",
       "      <td>5.830667</td>\n",
       "      <td>8.435000</td>\n",
       "      <td>6.495000</td>\n",
       "      <td>6.925333</td>\n",
       "      <td>7.094667</td>\n",
       "      <td>7.342333</td>\n",
       "      <td>7.237000</td>\n",
       "      <td>11.147333</td>\n",
       "      <td>10.278333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.860968</td>\n",
       "      <td>8.850000</td>\n",
       "      <td>10.818065</td>\n",
       "      <td>5.905333</td>\n",
       "      <td>9.490323</td>\n",
       "      <td>6.574839</td>\n",
       "      <td>7.604000</td>\n",
       "      <td>8.177097</td>\n",
       "      <td>8.039355</td>\n",
       "      <td>8.499355</td>\n",
       "      <td>11.900323</td>\n",
       "      <td>12.011613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15.5</td>\n",
       "      <td>9.904138</td>\n",
       "      <td>8.520333</td>\n",
       "      <td>8.867000</td>\n",
       "      <td>6.083000</td>\n",
       "      <td>10.824000</td>\n",
       "      <td>6.707333</td>\n",
       "      <td>9.095667</td>\n",
       "      <td>8.849333</td>\n",
       "      <td>9.086667</td>\n",
       "      <td>9.940333</td>\n",
       "      <td>13.995000</td>\n",
       "      <td>14.553793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16.0</td>\n",
       "      <td>10.614194</td>\n",
       "      <td>8.221613</td>\n",
       "      <td>9.110323</td>\n",
       "      <td>6.340968</td>\n",
       "      <td>10.532581</td>\n",
       "      <td>6.198387</td>\n",
       "      <td>8.353333</td>\n",
       "      <td>8.284194</td>\n",
       "      <td>8.077097</td>\n",
       "      <td>8.891613</td>\n",
       "      <td>11.092581</td>\n",
       "      <td>12.312903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16.0</td>\n",
       "      <td>12.035000</td>\n",
       "      <td>10.133871</td>\n",
       "      <td>10.335806</td>\n",
       "      <td>6.845806</td>\n",
       "      <td>12.715161</td>\n",
       "      <td>8.441935</td>\n",
       "      <td>10.093871</td>\n",
       "      <td>10.460968</td>\n",
       "      <td>9.111613</td>\n",
       "      <td>10.544667</td>\n",
       "      <td>14.410000</td>\n",
       "      <td>14.345333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>15.5</td>\n",
       "      <td>12.531000</td>\n",
       "      <td>9.656897</td>\n",
       "      <td>10.776897</td>\n",
       "      <td>7.155517</td>\n",
       "      <td>11.003333</td>\n",
       "      <td>7.234000</td>\n",
       "      <td>8.206000</td>\n",
       "      <td>8.936552</td>\n",
       "      <td>7.728333</td>\n",
       "      <td>9.931333</td>\n",
       "      <td>13.718333</td>\n",
       "      <td>12.921667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.289667</td>\n",
       "      <td>10.915806</td>\n",
       "      <td>12.236452</td>\n",
       "      <td>8.154839</td>\n",
       "      <td>11.865484</td>\n",
       "      <td>8.333871</td>\n",
       "      <td>11.194194</td>\n",
       "      <td>9.271935</td>\n",
       "      <td>8.942667</td>\n",
       "      <td>11.455806</td>\n",
       "      <td>14.229355</td>\n",
       "      <td>16.793226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>15.5</td>\n",
       "      <td>10.896333</td>\n",
       "      <td>8.592667</td>\n",
       "      <td>11.850333</td>\n",
       "      <td>6.045667</td>\n",
       "      <td>9.123667</td>\n",
       "      <td>6.250667</td>\n",
       "      <td>10.869655</td>\n",
       "      <td>6.313667</td>\n",
       "      <td>6.575000</td>\n",
       "      <td>8.383667</td>\n",
       "      <td>10.776667</td>\n",
       "      <td>12.146000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.973548</td>\n",
       "      <td>11.903871</td>\n",
       "      <td>13.980323</td>\n",
       "      <td>7.073871</td>\n",
       "      <td>11.323548</td>\n",
       "      <td>8.302258</td>\n",
       "      <td>11.753548</td>\n",
       "      <td>8.163226</td>\n",
       "      <td>7.965806</td>\n",
       "      <td>9.246774</td>\n",
       "      <td>12.239355</td>\n",
       "      <td>13.098710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"12\" valign=\"top\">62</th>\n",
       "      <th>1</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.783871</td>\n",
       "      <td>13.160323</td>\n",
       "      <td>12.591935</td>\n",
       "      <td>7.538065</td>\n",
       "      <td>11.779677</td>\n",
       "      <td>8.720000</td>\n",
       "      <td>14.211935</td>\n",
       "      <td>9.600000</td>\n",
       "      <td>9.670000</td>\n",
       "      <td>11.498710</td>\n",
       "      <td>16.369355</td>\n",
       "      <td>15.661613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.5</td>\n",
       "      <td>15.844643</td>\n",
       "      <td>12.041429</td>\n",
       "      <td>15.178929</td>\n",
       "      <td>9.262963</td>\n",
       "      <td>13.821429</td>\n",
       "      <td>9.726786</td>\n",
       "      <td>16.916429</td>\n",
       "      <td>11.285357</td>\n",
       "      <td>12.021071</td>\n",
       "      <td>12.126429</td>\n",
       "      <td>16.705357</td>\n",
       "      <td>18.426786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16.0</td>\n",
       "      <td>11.634333</td>\n",
       "      <td>8.602258</td>\n",
       "      <td>12.110645</td>\n",
       "      <td>6.403226</td>\n",
       "      <td>10.352258</td>\n",
       "      <td>6.732258</td>\n",
       "      <td>10.223226</td>\n",
       "      <td>7.641935</td>\n",
       "      <td>7.092258</td>\n",
       "      <td>8.052581</td>\n",
       "      <td>9.690000</td>\n",
       "      <td>11.509000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.5</td>\n",
       "      <td>12.160667</td>\n",
       "      <td>9.676667</td>\n",
       "      <td>12.088333</td>\n",
       "      <td>7.163000</td>\n",
       "      <td>10.544000</td>\n",
       "      <td>7.558000</td>\n",
       "      <td>11.480000</td>\n",
       "      <td>8.722000</td>\n",
       "      <td>8.703667</td>\n",
       "      <td>9.311667</td>\n",
       "      <td>12.234333</td>\n",
       "      <td>11.780667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16.0</td>\n",
       "      <td>12.745806</td>\n",
       "      <td>10.865484</td>\n",
       "      <td>11.874839</td>\n",
       "      <td>7.471935</td>\n",
       "      <td>11.285806</td>\n",
       "      <td>7.209032</td>\n",
       "      <td>10.105806</td>\n",
       "      <td>9.084516</td>\n",
       "      <td>7.868065</td>\n",
       "      <td>9.293226</td>\n",
       "      <td>12.130000</td>\n",
       "      <td>12.922581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15.5</td>\n",
       "      <td>10.305667</td>\n",
       "      <td>9.677000</td>\n",
       "      <td>9.996333</td>\n",
       "      <td>6.846667</td>\n",
       "      <td>10.711333</td>\n",
       "      <td>7.441333</td>\n",
       "      <td>10.548667</td>\n",
       "      <td>10.306667</td>\n",
       "      <td>9.196000</td>\n",
       "      <td>10.520333</td>\n",
       "      <td>13.757000</td>\n",
       "      <td>15.218333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.981935</td>\n",
       "      <td>8.370645</td>\n",
       "      <td>9.753548</td>\n",
       "      <td>6.093226</td>\n",
       "      <td>9.112903</td>\n",
       "      <td>5.877097</td>\n",
       "      <td>7.781613</td>\n",
       "      <td>8.123226</td>\n",
       "      <td>6.829677</td>\n",
       "      <td>8.613226</td>\n",
       "      <td>10.783871</td>\n",
       "      <td>11.326129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16.0</td>\n",
       "      <td>10.964194</td>\n",
       "      <td>9.694194</td>\n",
       "      <td>10.184516</td>\n",
       "      <td>6.701290</td>\n",
       "      <td>10.465161</td>\n",
       "      <td>7.009032</td>\n",
       "      <td>11.136774</td>\n",
       "      <td>9.097419</td>\n",
       "      <td>8.645484</td>\n",
       "      <td>9.511613</td>\n",
       "      <td>13.119032</td>\n",
       "      <td>15.420968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.176333</td>\n",
       "      <td>9.507000</td>\n",
       "      <td>11.640000</td>\n",
       "      <td>6.164333</td>\n",
       "      <td>9.722333</td>\n",
       "      <td>6.214000</td>\n",
       "      <td>8.488000</td>\n",
       "      <td>7.020333</td>\n",
       "      <td>6.372667</td>\n",
       "      <td>8.286000</td>\n",
       "      <td>11.483667</td>\n",
       "      <td>12.313333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.699355</td>\n",
       "      <td>8.063548</td>\n",
       "      <td>9.357097</td>\n",
       "      <td>4.818065</td>\n",
       "      <td>8.432258</td>\n",
       "      <td>5.730000</td>\n",
       "      <td>8.448065</td>\n",
       "      <td>7.626774</td>\n",
       "      <td>6.630645</td>\n",
       "      <td>9.091290</td>\n",
       "      <td>13.286774</td>\n",
       "      <td>14.090323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.071333</td>\n",
       "      <td>7.984000</td>\n",
       "      <td>12.035667</td>\n",
       "      <td>5.740000</td>\n",
       "      <td>8.135667</td>\n",
       "      <td>6.338333</td>\n",
       "      <td>9.615333</td>\n",
       "      <td>5.943000</td>\n",
       "      <td>6.362333</td>\n",
       "      <td>8.084333</td>\n",
       "      <td>9.786667</td>\n",
       "      <td>13.298333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16.0</td>\n",
       "      <td>16.785484</td>\n",
       "      <td>13.753548</td>\n",
       "      <td>14.276452</td>\n",
       "      <td>9.557419</td>\n",
       "      <td>13.724839</td>\n",
       "      <td>10.321613</td>\n",
       "      <td>13.735806</td>\n",
       "      <td>11.212258</td>\n",
       "      <td>10.683548</td>\n",
       "      <td>11.881935</td>\n",
       "      <td>16.043548</td>\n",
       "      <td>20.074516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">63</th>\n",
       "      <th>1</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.868387</td>\n",
       "      <td>11.112903</td>\n",
       "      <td>15.121613</td>\n",
       "      <td>6.635806</td>\n",
       "      <td>11.080645</td>\n",
       "      <td>7.835484</td>\n",
       "      <td>12.797419</td>\n",
       "      <td>9.844839</td>\n",
       "      <td>7.841613</td>\n",
       "      <td>9.390000</td>\n",
       "      <td>11.428710</td>\n",
       "      <td>18.822258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.5</td>\n",
       "      <td>14.418929</td>\n",
       "      <td>11.876429</td>\n",
       "      <td>15.697500</td>\n",
       "      <td>8.611786</td>\n",
       "      <td>12.887857</td>\n",
       "      <td>9.600357</td>\n",
       "      <td>12.729286</td>\n",
       "      <td>10.823214</td>\n",
       "      <td>8.981786</td>\n",
       "      <td>10.355714</td>\n",
       "      <td>13.266429</td>\n",
       "      <td>17.120714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.853871</td>\n",
       "      <td>12.271290</td>\n",
       "      <td>14.295806</td>\n",
       "      <td>9.268387</td>\n",
       "      <td>13.112903</td>\n",
       "      <td>10.088065</td>\n",
       "      <td>12.168387</td>\n",
       "      <td>11.340968</td>\n",
       "      <td>9.690968</td>\n",
       "      <td>11.515484</td>\n",
       "      <td>13.982903</td>\n",
       "      <td>14.132581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.616000</td>\n",
       "      <td>10.138000</td>\n",
       "      <td>13.233667</td>\n",
       "      <td>7.990333</td>\n",
       "      <td>11.515333</td>\n",
       "      <td>9.727000</td>\n",
       "      <td>11.979000</td>\n",
       "      <td>11.353000</td>\n",
       "      <td>10.341667</td>\n",
       "      <td>11.900333</td>\n",
       "      <td>13.875667</td>\n",
       "      <td>16.333667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16.0</td>\n",
       "      <td>12.879677</td>\n",
       "      <td>11.010645</td>\n",
       "      <td>12.881290</td>\n",
       "      <td>8.411613</td>\n",
       "      <td>12.981613</td>\n",
       "      <td>9.739677</td>\n",
       "      <td>12.280968</td>\n",
       "      <td>10.964194</td>\n",
       "      <td>10.745161</td>\n",
       "      <td>11.394839</td>\n",
       "      <td>14.777097</td>\n",
       "      <td>14.975161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15.5</td>\n",
       "      <td>10.623333</td>\n",
       "      <td>8.434667</td>\n",
       "      <td>11.685000</td>\n",
       "      <td>6.420333</td>\n",
       "      <td>10.142667</td>\n",
       "      <td>7.219333</td>\n",
       "      <td>9.267333</td>\n",
       "      <td>9.589333</td>\n",
       "      <td>8.583667</td>\n",
       "      <td>9.585333</td>\n",
       "      <td>12.098000</td>\n",
       "      <td>11.358667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">76</th>\n",
       "      <th>7</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.687742</td>\n",
       "      <td>7.980968</td>\n",
       "      <td>8.267742</td>\n",
       "      <td>4.631613</td>\n",
       "      <td>7.576774</td>\n",
       "      <td>4.927419</td>\n",
       "      <td>6.994839</td>\n",
       "      <td>5.135806</td>\n",
       "      <td>7.941290</td>\n",
       "      <td>6.491290</td>\n",
       "      <td>10.264194</td>\n",
       "      <td>11.912258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16.0</td>\n",
       "      <td>7.640645</td>\n",
       "      <td>5.366129</td>\n",
       "      <td>9.000645</td>\n",
       "      <td>3.142258</td>\n",
       "      <td>4.695484</td>\n",
       "      <td>3.847742</td>\n",
       "      <td>5.437097</td>\n",
       "      <td>3.362581</td>\n",
       "      <td>5.946452</td>\n",
       "      <td>4.496452</td>\n",
       "      <td>7.079677</td>\n",
       "      <td>9.438387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.703667</td>\n",
       "      <td>10.515333</td>\n",
       "      <td>10.466333</td>\n",
       "      <td>5.313333</td>\n",
       "      <td>8.761333</td>\n",
       "      <td>7.062333</td>\n",
       "      <td>8.617667</td>\n",
       "      <td>6.415333</td>\n",
       "      <td>8.953333</td>\n",
       "      <td>7.263333</td>\n",
       "      <td>11.587000</td>\n",
       "      <td>17.634000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16.0</td>\n",
       "      <td>12.427097</td>\n",
       "      <td>9.572258</td>\n",
       "      <td>10.640000</td>\n",
       "      <td>4.885484</td>\n",
       "      <td>9.393548</td>\n",
       "      <td>6.906452</td>\n",
       "      <td>6.380323</td>\n",
       "      <td>6.933226</td>\n",
       "      <td>7.552258</td>\n",
       "      <td>7.449032</td>\n",
       "      <td>11.837742</td>\n",
       "      <td>15.078065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>15.5</td>\n",
       "      <td>10.962667</td>\n",
       "      <td>9.443667</td>\n",
       "      <td>9.202000</td>\n",
       "      <td>3.696000</td>\n",
       "      <td>7.459333</td>\n",
       "      <td>7.026333</td>\n",
       "      <td>9.058333</td>\n",
       "      <td>5.791000</td>\n",
       "      <td>6.577000</td>\n",
       "      <td>7.512333</td>\n",
       "      <td>12.568333</td>\n",
       "      <td>15.685333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16.0</td>\n",
       "      <td>11.962258</td>\n",
       "      <td>10.086774</td>\n",
       "      <td>10.474516</td>\n",
       "      <td>3.383871</td>\n",
       "      <td>7.645484</td>\n",
       "      <td>6.148387</td>\n",
       "      <td>8.034516</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>5.952258</td>\n",
       "      <td>6.147742</td>\n",
       "      <td>7.814839</td>\n",
       "      <td>14.346774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"12\" valign=\"top\">77</th>\n",
       "      <th>1</th>\n",
       "      <td>16.0</td>\n",
       "      <td>13.404516</td>\n",
       "      <td>10.377742</td>\n",
       "      <td>12.764839</td>\n",
       "      <td>5.884516</td>\n",
       "      <td>9.159677</td>\n",
       "      <td>8.005161</td>\n",
       "      <td>10.107419</td>\n",
       "      <td>7.211613</td>\n",
       "      <td>8.280000</td>\n",
       "      <td>9.328387</td>\n",
       "      <td>12.131935</td>\n",
       "      <td>18.830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.5</td>\n",
       "      <td>12.336786</td>\n",
       "      <td>11.898929</td>\n",
       "      <td>12.016786</td>\n",
       "      <td>5.317500</td>\n",
       "      <td>10.134643</td>\n",
       "      <td>9.423929</td>\n",
       "      <td>10.949643</td>\n",
       "      <td>7.965357</td>\n",
       "      <td>9.320000</td>\n",
       "      <td>8.711429</td>\n",
       "      <td>11.435357</td>\n",
       "      <td>17.561429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16.0</td>\n",
       "      <td>16.750000</td>\n",
       "      <td>14.499677</td>\n",
       "      <td>16.118387</td>\n",
       "      <td>8.414516</td>\n",
       "      <td>13.293871</td>\n",
       "      <td>11.562258</td>\n",
       "      <td>14.283226</td>\n",
       "      <td>11.361613</td>\n",
       "      <td>12.102581</td>\n",
       "      <td>11.906452</td>\n",
       "      <td>15.863226</td>\n",
       "      <td>19.133548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.5</td>\n",
       "      <td>14.955333</td>\n",
       "      <td>12.293000</td>\n",
       "      <td>12.689667</td>\n",
       "      <td>7.422333</td>\n",
       "      <td>11.740000</td>\n",
       "      <td>10.137000</td>\n",
       "      <td>13.887667</td>\n",
       "      <td>9.574000</td>\n",
       "      <td>10.342333</td>\n",
       "      <td>11.419667</td>\n",
       "      <td>15.593667</td>\n",
       "      <td>18.274667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.441290</td>\n",
       "      <td>7.173871</td>\n",
       "      <td>12.455806</td>\n",
       "      <td>4.507742</td>\n",
       "      <td>6.198387</td>\n",
       "      <td>6.689677</td>\n",
       "      <td>9.226452</td>\n",
       "      <td>5.638387</td>\n",
       "      <td>6.699355</td>\n",
       "      <td>6.045484</td>\n",
       "      <td>10.213548</td>\n",
       "      <td>11.936129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.040000</td>\n",
       "      <td>8.353000</td>\n",
       "      <td>12.228000</td>\n",
       "      <td>4.864000</td>\n",
       "      <td>8.790333</td>\n",
       "      <td>7.209667</td>\n",
       "      <td>8.799667</td>\n",
       "      <td>5.931000</td>\n",
       "      <td>7.065333</td>\n",
       "      <td>6.583333</td>\n",
       "      <td>11.321333</td>\n",
       "      <td>11.175333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16.0</td>\n",
       "      <td>10.881935</td>\n",
       "      <td>8.663548</td>\n",
       "      <td>10.816452</td>\n",
       "      <td>5.419677</td>\n",
       "      <td>9.014839</td>\n",
       "      <td>7.600000</td>\n",
       "      <td>9.961935</td>\n",
       "      <td>6.526129</td>\n",
       "      <td>7.980968</td>\n",
       "      <td>7.620000</td>\n",
       "      <td>12.924194</td>\n",
       "      <td>12.186774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.233548</td>\n",
       "      <td>7.727742</td>\n",
       "      <td>10.679032</td>\n",
       "      <td>4.453871</td>\n",
       "      <td>6.620645</td>\n",
       "      <td>5.961290</td>\n",
       "      <td>8.943548</td>\n",
       "      <td>4.543226</td>\n",
       "      <td>6.384839</td>\n",
       "      <td>5.694839</td>\n",
       "      <td>9.825161</td>\n",
       "      <td>11.659355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>15.5</td>\n",
       "      <td>12.472333</td>\n",
       "      <td>10.742667</td>\n",
       "      <td>11.849333</td>\n",
       "      <td>5.638667</td>\n",
       "      <td>10.077333</td>\n",
       "      <td>8.242667</td>\n",
       "      <td>11.939333</td>\n",
       "      <td>7.923000</td>\n",
       "      <td>8.828000</td>\n",
       "      <td>8.506333</td>\n",
       "      <td>14.051000</td>\n",
       "      <td>17.030333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16.0</td>\n",
       "      <td>15.004516</td>\n",
       "      <td>13.960000</td>\n",
       "      <td>12.819677</td>\n",
       "      <td>6.754194</td>\n",
       "      <td>11.779032</td>\n",
       "      <td>9.671613</td>\n",
       "      <td>12.924839</td>\n",
       "      <td>11.875161</td>\n",
       "      <td>11.481290</td>\n",
       "      <td>10.340323</td>\n",
       "      <td>17.640968</td>\n",
       "      <td>19.842903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>15.5</td>\n",
       "      <td>16.946667</td>\n",
       "      <td>15.444667</td>\n",
       "      <td>13.561333</td>\n",
       "      <td>7.584000</td>\n",
       "      <td>12.088667</td>\n",
       "      <td>9.161333</td>\n",
       "      <td>14.051000</td>\n",
       "      <td>11.286000</td>\n",
       "      <td>10.318667</td>\n",
       "      <td>10.327000</td>\n",
       "      <td>17.215333</td>\n",
       "      <td>22.333000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.751935</td>\n",
       "      <td>12.744839</td>\n",
       "      <td>13.469677</td>\n",
       "      <td>6.592258</td>\n",
       "      <td>11.247742</td>\n",
       "      <td>9.466774</td>\n",
       "      <td>13.231613</td>\n",
       "      <td>10.703871</td>\n",
       "      <td>10.401613</td>\n",
       "      <td>9.415484</td>\n",
       "      <td>13.237419</td>\n",
       "      <td>19.299677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"12\" valign=\"top\">78</th>\n",
       "      <th>1</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.291935</td>\n",
       "      <td>11.872258</td>\n",
       "      <td>12.014194</td>\n",
       "      <td>6.463226</td>\n",
       "      <td>11.402903</td>\n",
       "      <td>7.517097</td>\n",
       "      <td>12.207097</td>\n",
       "      <td>10.206452</td>\n",
       "      <td>9.549032</td>\n",
       "      <td>9.247419</td>\n",
       "      <td>15.101613</td>\n",
       "      <td>20.715806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.5</td>\n",
       "      <td>14.143571</td>\n",
       "      <td>12.153214</td>\n",
       "      <td>13.803214</td>\n",
       "      <td>6.828929</td>\n",
       "      <td>11.196786</td>\n",
       "      <td>7.858929</td>\n",
       "      <td>11.903214</td>\n",
       "      <td>11.068929</td>\n",
       "      <td>10.052143</td>\n",
       "      <td>8.093929</td>\n",
       "      <td>10.353929</td>\n",
       "      <td>17.298571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16.0</td>\n",
       "      <td>14.717097</td>\n",
       "      <td>14.601935</td>\n",
       "      <td>13.334194</td>\n",
       "      <td>8.231290</td>\n",
       "      <td>12.783226</td>\n",
       "      <td>9.488710</td>\n",
       "      <td>12.129355</td>\n",
       "      <td>11.665161</td>\n",
       "      <td>11.656452</td>\n",
       "      <td>9.657097</td>\n",
       "      <td>14.234194</td>\n",
       "      <td>18.611290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.805000</td>\n",
       "      <td>11.255667</td>\n",
       "      <td>12.516333</td>\n",
       "      <td>5.920333</td>\n",
       "      <td>10.218000</td>\n",
       "      <td>7.301667</td>\n",
       "      <td>8.586333</td>\n",
       "      <td>8.306667</td>\n",
       "      <td>8.537000</td>\n",
       "      <td>6.999000</td>\n",
       "      <td>11.190667</td>\n",
       "      <td>14.152000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16.0</td>\n",
       "      <td>8.270645</td>\n",
       "      <td>7.226774</td>\n",
       "      <td>6.901613</td>\n",
       "      <td>3.740645</td>\n",
       "      <td>6.973871</td>\n",
       "      <td>4.449677</td>\n",
       "      <td>5.420968</td>\n",
       "      <td>6.130645</td>\n",
       "      <td>5.742581</td>\n",
       "      <td>5.926452</td>\n",
       "      <td>9.263548</td>\n",
       "      <td>10.756452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15.5</td>\n",
       "      <td>11.386667</td>\n",
       "      <td>9.474333</td>\n",
       "      <td>10.253333</td>\n",
       "      <td>6.053000</td>\n",
       "      <td>10.395333</td>\n",
       "      <td>7.490333</td>\n",
       "      <td>7.928000</td>\n",
       "      <td>7.802000</td>\n",
       "      <td>8.220333</td>\n",
       "      <td>7.550000</td>\n",
       "      <td>11.501000</td>\n",
       "      <td>15.078667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16.0</td>\n",
       "      <td>12.820000</td>\n",
       "      <td>9.750968</td>\n",
       "      <td>9.910323</td>\n",
       "      <td>6.483871</td>\n",
       "      <td>10.055161</td>\n",
       "      <td>7.820645</td>\n",
       "      <td>7.831935</td>\n",
       "      <td>8.459355</td>\n",
       "      <td>8.523871</td>\n",
       "      <td>7.732903</td>\n",
       "      <td>12.648710</td>\n",
       "      <td>14.077419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.645161</td>\n",
       "      <td>8.259355</td>\n",
       "      <td>9.032258</td>\n",
       "      <td>4.502903</td>\n",
       "      <td>7.368065</td>\n",
       "      <td>5.935161</td>\n",
       "      <td>5.650323</td>\n",
       "      <td>5.417742</td>\n",
       "      <td>7.241290</td>\n",
       "      <td>5.536774</td>\n",
       "      <td>10.466774</td>\n",
       "      <td>12.054194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>15.5</td>\n",
       "      <td>10.913667</td>\n",
       "      <td>10.895000</td>\n",
       "      <td>10.635000</td>\n",
       "      <td>5.725000</td>\n",
       "      <td>10.372000</td>\n",
       "      <td>9.278333</td>\n",
       "      <td>10.790333</td>\n",
       "      <td>9.583000</td>\n",
       "      <td>10.069333</td>\n",
       "      <td>8.939000</td>\n",
       "      <td>15.680333</td>\n",
       "      <td>19.391333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16.0</td>\n",
       "      <td>9.897742</td>\n",
       "      <td>8.670968</td>\n",
       "      <td>9.295806</td>\n",
       "      <td>4.721290</td>\n",
       "      <td>8.525161</td>\n",
       "      <td>6.774194</td>\n",
       "      <td>8.115484</td>\n",
       "      <td>7.337742</td>\n",
       "      <td>8.297742</td>\n",
       "      <td>8.243871</td>\n",
       "      <td>13.776774</td>\n",
       "      <td>17.150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>15.5</td>\n",
       "      <td>16.151667</td>\n",
       "      <td>14.802667</td>\n",
       "      <td>13.508000</td>\n",
       "      <td>7.317333</td>\n",
       "      <td>11.475000</td>\n",
       "      <td>8.743000</td>\n",
       "      <td>11.492333</td>\n",
       "      <td>9.657333</td>\n",
       "      <td>10.701333</td>\n",
       "      <td>10.676000</td>\n",
       "      <td>17.404667</td>\n",
       "      <td>20.723000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16.0</td>\n",
       "      <td>16.175484</td>\n",
       "      <td>13.748065</td>\n",
       "      <td>15.635161</td>\n",
       "      <td>7.094839</td>\n",
       "      <td>11.398710</td>\n",
       "      <td>9.241613</td>\n",
       "      <td>12.077419</td>\n",
       "      <td>10.194839</td>\n",
       "      <td>10.616774</td>\n",
       "      <td>11.028710</td>\n",
       "      <td>13.859677</td>\n",
       "      <td>21.371613</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>216 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Dy        RPT        VAL        ROS       KIL        SHA        BIR  \\\n",
       "Yr Mo                                                                          \n",
       "61 1   16.0  14.841333  11.988333  13.431613  7.736774  11.072759   8.588065   \n",
       "   2   14.5  16.269286  14.975357  14.441481  9.230741  13.852143  10.937500   \n",
       "   3   16.0  10.890000  11.296452  10.752903  7.284000  10.509355   8.866774   \n",
       "   4   15.5  10.722667   9.427667   9.998000  5.830667   8.435000   6.495000   \n",
       "   5   16.0   9.860968   8.850000  10.818065  5.905333   9.490323   6.574839   \n",
       "   6   15.5   9.904138   8.520333   8.867000  6.083000  10.824000   6.707333   \n",
       "   7   16.0  10.614194   8.221613   9.110323  6.340968  10.532581   6.198387   \n",
       "   8   16.0  12.035000  10.133871  10.335806  6.845806  12.715161   8.441935   \n",
       "   9   15.5  12.531000   9.656897  10.776897  7.155517  11.003333   7.234000   \n",
       "   10  16.0  14.289667  10.915806  12.236452  8.154839  11.865484   8.333871   \n",
       "   11  15.5  10.896333   8.592667  11.850333  6.045667   9.123667   6.250667   \n",
       "   12  16.0  14.973548  11.903871  13.980323  7.073871  11.323548   8.302258   \n",
       "62 1   16.0  14.783871  13.160323  12.591935  7.538065  11.779677   8.720000   \n",
       "   2   14.5  15.844643  12.041429  15.178929  9.262963  13.821429   9.726786   \n",
       "   3   16.0  11.634333   8.602258  12.110645  6.403226  10.352258   6.732258   \n",
       "   4   15.5  12.160667   9.676667  12.088333  7.163000  10.544000   7.558000   \n",
       "   5   16.0  12.745806  10.865484  11.874839  7.471935  11.285806   7.209032   \n",
       "   6   15.5  10.305667   9.677000   9.996333  6.846667  10.711333   7.441333   \n",
       "   7   16.0   9.981935   8.370645   9.753548  6.093226   9.112903   5.877097   \n",
       "   8   16.0  10.964194   9.694194  10.184516  6.701290  10.465161   7.009032   \n",
       "   9   15.5  11.176333   9.507000  11.640000  6.164333   9.722333   6.214000   \n",
       "   10  16.0   9.699355   8.063548   9.357097  4.818065   8.432258   5.730000   \n",
       "   11  15.5  11.071333   7.984000  12.035667  5.740000   8.135667   6.338333   \n",
       "   12  16.0  16.785484  13.753548  14.276452  9.557419  13.724839  10.321613   \n",
       "63 1   16.0  14.868387  11.112903  15.121613  6.635806  11.080645   7.835484   \n",
       "   2   14.5  14.418929  11.876429  15.697500  8.611786  12.887857   9.600357   \n",
       "   3   16.0  14.853871  12.271290  14.295806  9.268387  13.112903  10.088065   \n",
       "   4   15.5  11.616000  10.138000  13.233667  7.990333  11.515333   9.727000   \n",
       "   5   16.0  12.879677  11.010645  12.881290  8.411613  12.981613   9.739677   \n",
       "   6   15.5  10.623333   8.434667  11.685000  6.420333  10.142667   7.219333   \n",
       "...     ...        ...        ...        ...       ...        ...        ...   \n",
       "76 7   16.0   9.687742   7.980968   8.267742  4.631613   7.576774   4.927419   \n",
       "   8   16.0   7.640645   5.366129   9.000645  3.142258   4.695484   3.847742   \n",
       "   9   15.5  11.703667  10.515333  10.466333  5.313333   8.761333   7.062333   \n",
       "   10  16.0  12.427097   9.572258  10.640000  4.885484   9.393548   6.906452   \n",
       "   11  15.5  10.962667   9.443667   9.202000  3.696000   7.459333   7.026333   \n",
       "   12  16.0  11.962258  10.086774  10.474516  3.383871   7.645484   6.148387   \n",
       "77 1   16.0  13.404516  10.377742  12.764839  5.884516   9.159677   8.005161   \n",
       "   2   14.5  12.336786  11.898929  12.016786  5.317500  10.134643   9.423929   \n",
       "   3   16.0  16.750000  14.499677  16.118387  8.414516  13.293871  11.562258   \n",
       "   4   15.5  14.955333  12.293000  12.689667  7.422333  11.740000  10.137000   \n",
       "   5   16.0   9.441290   7.173871  12.455806  4.507742   6.198387   6.689677   \n",
       "   6   15.5  11.040000   8.353000  12.228000  4.864000   8.790333   7.209667   \n",
       "   7   16.0  10.881935   8.663548  10.816452  5.419677   9.014839   7.600000   \n",
       "   8   16.0   9.233548   7.727742  10.679032  4.453871   6.620645   5.961290   \n",
       "   9   15.5  12.472333  10.742667  11.849333  5.638667  10.077333   8.242667   \n",
       "   10  16.0  15.004516  13.960000  12.819677  6.754194  11.779032   9.671613   \n",
       "   11  15.5  16.946667  15.444667  13.561333  7.584000  12.088667   9.161333   \n",
       "   12  16.0  14.751935  12.744839  13.469677  6.592258  11.247742   9.466774   \n",
       "78 1   16.0  14.291935  11.872258  12.014194  6.463226  11.402903   7.517097   \n",
       "   2   14.5  14.143571  12.153214  13.803214  6.828929  11.196786   7.858929   \n",
       "   3   16.0  14.717097  14.601935  13.334194  8.231290  12.783226   9.488710   \n",
       "   4   15.5  11.805000  11.255667  12.516333  5.920333  10.218000   7.301667   \n",
       "   5   16.0   8.270645   7.226774   6.901613  3.740645   6.973871   4.449677   \n",
       "   6   15.5  11.386667   9.474333  10.253333  6.053000  10.395333   7.490333   \n",
       "   7   16.0  12.820000   9.750968   9.910323  6.483871  10.055161   7.820645   \n",
       "   8   16.0   9.645161   8.259355   9.032258  4.502903   7.368065   5.935161   \n",
       "   9   15.5  10.913667  10.895000  10.635000  5.725000  10.372000   9.278333   \n",
       "   10  16.0   9.897742   8.670968   9.295806  4.721290   8.525161   6.774194   \n",
       "   11  15.5  16.151667  14.802667  13.508000  7.317333  11.475000   8.743000   \n",
       "   12  16.0  16.175484  13.748065  15.635161  7.094839  11.398710   9.241613   \n",
       "\n",
       "             DUB        CLA        MUL        CLO        BEL        MAL  \n",
       "Yr Mo                                                                    \n",
       "61 1   11.184839   9.245333   9.085806  10.107419  13.880968  14.703226  \n",
       "   2   11.890714  11.846071  11.821429  12.714286  18.583214  15.411786  \n",
       "   3    9.644194   9.829677  10.294138  11.251935  16.410968  15.720000  \n",
       "   4    6.925333   7.094667   7.342333   7.237000  11.147333  10.278333  \n",
       "   5    7.604000   8.177097   8.039355   8.499355  11.900323  12.011613  \n",
       "   6    9.095667   8.849333   9.086667   9.940333  13.995000  14.553793  \n",
       "   7    8.353333   8.284194   8.077097   8.891613  11.092581  12.312903  \n",
       "   8   10.093871  10.460968   9.111613  10.544667  14.410000  14.345333  \n",
       "   9    8.206000   8.936552   7.728333   9.931333  13.718333  12.921667  \n",
       "   10  11.194194   9.271935   8.942667  11.455806  14.229355  16.793226  \n",
       "   11  10.869655   6.313667   6.575000   8.383667  10.776667  12.146000  \n",
       "   12  11.753548   8.163226   7.965806   9.246774  12.239355  13.098710  \n",
       "62 1   14.211935   9.600000   9.670000  11.498710  16.369355  15.661613  \n",
       "   2   16.916429  11.285357  12.021071  12.126429  16.705357  18.426786  \n",
       "   3   10.223226   7.641935   7.092258   8.052581   9.690000  11.509000  \n",
       "   4   11.480000   8.722000   8.703667   9.311667  12.234333  11.780667  \n",
       "   5   10.105806   9.084516   7.868065   9.293226  12.130000  12.922581  \n",
       "   6   10.548667  10.306667   9.196000  10.520333  13.757000  15.218333  \n",
       "   7    7.781613   8.123226   6.829677   8.613226  10.783871  11.326129  \n",
       "   8   11.136774   9.097419   8.645484   9.511613  13.119032  15.420968  \n",
       "   9    8.488000   7.020333   6.372667   8.286000  11.483667  12.313333  \n",
       "   10   8.448065   7.626774   6.630645   9.091290  13.286774  14.090323  \n",
       "   11   9.615333   5.943000   6.362333   8.084333   9.786667  13.298333  \n",
       "   12  13.735806  11.212258  10.683548  11.881935  16.043548  20.074516  \n",
       "63 1   12.797419   9.844839   7.841613   9.390000  11.428710  18.822258  \n",
       "   2   12.729286  10.823214   8.981786  10.355714  13.266429  17.120714  \n",
       "   3   12.168387  11.340968   9.690968  11.515484  13.982903  14.132581  \n",
       "   4   11.979000  11.353000  10.341667  11.900333  13.875667  16.333667  \n",
       "   5   12.280968  10.964194  10.745161  11.394839  14.777097  14.975161  \n",
       "   6    9.267333   9.589333   8.583667   9.585333  12.098000  11.358667  \n",
       "...          ...        ...        ...        ...        ...        ...  \n",
       "76 7    6.994839   5.135806   7.941290   6.491290  10.264194  11.912258  \n",
       "   8    5.437097   3.362581   5.946452   4.496452   7.079677   9.438387  \n",
       "   9    8.617667   6.415333   8.953333   7.263333  11.587000  17.634000  \n",
       "   10   6.380323   6.933226   7.552258   7.449032  11.837742  15.078065  \n",
       "   11   9.058333   5.791000   6.577000   7.512333  12.568333  15.685333  \n",
       "   12   8.034516   4.500000   5.952258   6.147742   7.814839  14.346774  \n",
       "77 1   10.107419   7.211613   8.280000   9.328387  12.131935  18.830000  \n",
       "   2   10.949643   7.965357   9.320000   8.711429  11.435357  17.561429  \n",
       "   3   14.283226  11.361613  12.102581  11.906452  15.863226  19.133548  \n",
       "   4   13.887667   9.574000  10.342333  11.419667  15.593667  18.274667  \n",
       "   5    9.226452   5.638387   6.699355   6.045484  10.213548  11.936129  \n",
       "   6    8.799667   5.931000   7.065333   6.583333  11.321333  11.175333  \n",
       "   7    9.961935   6.526129   7.980968   7.620000  12.924194  12.186774  \n",
       "   8    8.943548   4.543226   6.384839   5.694839   9.825161  11.659355  \n",
       "   9   11.939333   7.923000   8.828000   8.506333  14.051000  17.030333  \n",
       "   10  12.924839  11.875161  11.481290  10.340323  17.640968  19.842903  \n",
       "   11  14.051000  11.286000  10.318667  10.327000  17.215333  22.333000  \n",
       "   12  13.231613  10.703871  10.401613   9.415484  13.237419  19.299677  \n",
       "78 1   12.207097  10.206452   9.549032   9.247419  15.101613  20.715806  \n",
       "   2   11.903214  11.068929  10.052143   8.093929  10.353929  17.298571  \n",
       "   3   12.129355  11.665161  11.656452   9.657097  14.234194  18.611290  \n",
       "   4    8.586333   8.306667   8.537000   6.999000  11.190667  14.152000  \n",
       "   5    5.420968   6.130645   5.742581   5.926452   9.263548  10.756452  \n",
       "   6    7.928000   7.802000   8.220333   7.550000  11.501000  15.078667  \n",
       "   7    7.831935   8.459355   8.523871   7.732903  12.648710  14.077419  \n",
       "   8    5.650323   5.417742   7.241290   5.536774  10.466774  12.054194  \n",
       "   9   10.790333   9.583000  10.069333   8.939000  15.680333  19.391333  \n",
       "   10   8.115484   7.337742   8.297742   8.243871  13.776774  17.150000  \n",
       "   11  11.492333   9.657333  10.701333  10.676000  17.404667  20.723000  \n",
       "   12  12.077419  10.194839  10.616774  11.028710  13.859677  21.371613  \n",
       "\n",
       "[216 rows x 13 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby([data.Yr, data.Mo]).mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 步骤12 全国境内平均风速最大的是几月？"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Yr</th>\n",
       "      <th>Dy</th>\n",
       "      <th>RPT</th>\n",
       "      <th>VAL</th>\n",
       "      <th>ROS</th>\n",
       "      <th>KIL</th>\n",
       "      <th>SHA</th>\n",
       "      <th>BIR</th>\n",
       "      <th>DUB</th>\n",
       "      <th>CLA</th>\n",
       "      <th>MUL</th>\n",
       "      <th>CLO</th>\n",
       "      <th>BEL</th>\n",
       "      <th>MAL</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mo</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>14.847325</td>\n",
       "      <td>12.914560</td>\n",
       "      <td>13.299624</td>\n",
       "      <td>7.199498</td>\n",
       "      <td>11.667734</td>\n",
       "      <td>8.054839</td>\n",
       "      <td>11.819355</td>\n",
       "      <td>9.512047</td>\n",
       "      <td>9.543208</td>\n",
       "      <td>10.053566</td>\n",
       "      <td>14.550520</td>\n",
       "      <td>18.028763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>69.503937</td>\n",
       "      <td>14.614173</td>\n",
       "      <td>13.710906</td>\n",
       "      <td>12.111122</td>\n",
       "      <td>12.879132</td>\n",
       "      <td>6.942411</td>\n",
       "      <td>11.551772</td>\n",
       "      <td>7.633858</td>\n",
       "      <td>11.206024</td>\n",
       "      <td>9.341437</td>\n",
       "      <td>9.313169</td>\n",
       "      <td>9.518051</td>\n",
       "      <td>13.728898</td>\n",
       "      <td>17.156142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>13.158687</td>\n",
       "      <td>11.505842</td>\n",
       "      <td>12.648118</td>\n",
       "      <td>7.265907</td>\n",
       "      <td>11.554516</td>\n",
       "      <td>7.959409</td>\n",
       "      <td>11.310179</td>\n",
       "      <td>9.635896</td>\n",
       "      <td>9.700324</td>\n",
       "      <td>10.096953</td>\n",
       "      <td>13.810609</td>\n",
       "      <td>16.909317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>15.500000</td>\n",
       "      <td>12.555648</td>\n",
       "      <td>10.429759</td>\n",
       "      <td>12.204815</td>\n",
       "      <td>6.898037</td>\n",
       "      <td>10.677667</td>\n",
       "      <td>7.441389</td>\n",
       "      <td>10.221315</td>\n",
       "      <td>8.909056</td>\n",
       "      <td>8.930870</td>\n",
       "      <td>9.158019</td>\n",
       "      <td>12.664759</td>\n",
       "      <td>14.937611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>11.724032</td>\n",
       "      <td>10.145619</td>\n",
       "      <td>11.550394</td>\n",
       "      <td>6.307487</td>\n",
       "      <td>10.224301</td>\n",
       "      <td>6.942061</td>\n",
       "      <td>8.797738</td>\n",
       "      <td>8.452903</td>\n",
       "      <td>8.040806</td>\n",
       "      <td>8.524857</td>\n",
       "      <td>12.767258</td>\n",
       "      <td>13.736039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>15.500000</td>\n",
       "      <td>10.451317</td>\n",
       "      <td>8.949704</td>\n",
       "      <td>10.361315</td>\n",
       "      <td>5.652278</td>\n",
       "      <td>9.529926</td>\n",
       "      <td>6.410093</td>\n",
       "      <td>8.009556</td>\n",
       "      <td>7.920796</td>\n",
       "      <td>7.639796</td>\n",
       "      <td>7.729185</td>\n",
       "      <td>12.246407</td>\n",
       "      <td>12.861818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>9.992007</td>\n",
       "      <td>8.357778</td>\n",
       "      <td>9.349642</td>\n",
       "      <td>5.416935</td>\n",
       "      <td>9.302634</td>\n",
       "      <td>5.972348</td>\n",
       "      <td>7.843501</td>\n",
       "      <td>7.262760</td>\n",
       "      <td>7.544480</td>\n",
       "      <td>7.321416</td>\n",
       "      <td>11.676505</td>\n",
       "      <td>12.800789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>10.213411</td>\n",
       "      <td>8.415143</td>\n",
       "      <td>9.993441</td>\n",
       "      <td>5.270681</td>\n",
       "      <td>8.901559</td>\n",
       "      <td>5.891057</td>\n",
       "      <td>7.772312</td>\n",
       "      <td>6.842025</td>\n",
       "      <td>7.240573</td>\n",
       "      <td>7.002783</td>\n",
       "      <td>11.110090</td>\n",
       "      <td>12.565943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>15.500000</td>\n",
       "      <td>11.458519</td>\n",
       "      <td>9.981002</td>\n",
       "      <td>10.756883</td>\n",
       "      <td>5.615176</td>\n",
       "      <td>9.766315</td>\n",
       "      <td>6.566222</td>\n",
       "      <td>8.609722</td>\n",
       "      <td>7.745677</td>\n",
       "      <td>7.610556</td>\n",
       "      <td>7.689278</td>\n",
       "      <td>12.686389</td>\n",
       "      <td>14.761963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>12.660610</td>\n",
       "      <td>11.010681</td>\n",
       "      <td>11.453943</td>\n",
       "      <td>6.065215</td>\n",
       "      <td>10.550251</td>\n",
       "      <td>7.159910</td>\n",
       "      <td>9.387778</td>\n",
       "      <td>8.726308</td>\n",
       "      <td>8.347181</td>\n",
       "      <td>8.850376</td>\n",
       "      <td>14.155323</td>\n",
       "      <td>16.697151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>15.500000</td>\n",
       "      <td>13.200722</td>\n",
       "      <td>11.639500</td>\n",
       "      <td>12.293407</td>\n",
       "      <td>6.247611</td>\n",
       "      <td>10.501130</td>\n",
       "      <td>7.134333</td>\n",
       "      <td>10.814861</td>\n",
       "      <td>8.427167</td>\n",
       "      <td>8.604000</td>\n",
       "      <td>8.943167</td>\n",
       "      <td>13.815741</td>\n",
       "      <td>18.114185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>69.500000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>14.446398</td>\n",
       "      <td>12.353602</td>\n",
       "      <td>13.212276</td>\n",
       "      <td>6.829910</td>\n",
       "      <td>11.301254</td>\n",
       "      <td>7.963710</td>\n",
       "      <td>11.849050</td>\n",
       "      <td>9.209355</td>\n",
       "      <td>9.447258</td>\n",
       "      <td>9.627670</td>\n",
       "      <td>14.259516</td>\n",
       "      <td>18.697599</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Yr         Dy        RPT        VAL        ROS       KIL  \\\n",
       "Mo                                                                    \n",
       "1   69.500000  16.000000  14.847325  12.914560  13.299624  7.199498   \n",
       "2   69.503937  14.614173  13.710906  12.111122  12.879132  6.942411   \n",
       "3   69.500000  16.000000  13.158687  11.505842  12.648118  7.265907   \n",
       "4   69.500000  15.500000  12.555648  10.429759  12.204815  6.898037   \n",
       "5   69.500000  16.000000  11.724032  10.145619  11.550394  6.307487   \n",
       "6   69.500000  15.500000  10.451317   8.949704  10.361315  5.652278   \n",
       "7   69.500000  16.000000   9.992007   8.357778   9.349642  5.416935   \n",
       "8   69.500000  16.000000  10.213411   8.415143   9.993441  5.270681   \n",
       "9   69.500000  15.500000  11.458519   9.981002  10.756883  5.615176   \n",
       "10  69.500000  16.000000  12.660610  11.010681  11.453943  6.065215   \n",
       "11  69.500000  15.500000  13.200722  11.639500  12.293407  6.247611   \n",
       "12  69.500000  16.000000  14.446398  12.353602  13.212276  6.829910   \n",
       "\n",
       "          SHA       BIR        DUB       CLA       MUL        CLO        BEL  \\\n",
       "Mo                                                                             \n",
       "1   11.667734  8.054839  11.819355  9.512047  9.543208  10.053566  14.550520   \n",
       "2   11.551772  7.633858  11.206024  9.341437  9.313169   9.518051  13.728898   \n",
       "3   11.554516  7.959409  11.310179  9.635896  9.700324  10.096953  13.810609   \n",
       "4   10.677667  7.441389  10.221315  8.909056  8.930870   9.158019  12.664759   \n",
       "5   10.224301  6.942061   8.797738  8.452903  8.040806   8.524857  12.767258   \n",
       "6    9.529926  6.410093   8.009556  7.920796  7.639796   7.729185  12.246407   \n",
       "7    9.302634  5.972348   7.843501  7.262760  7.544480   7.321416  11.676505   \n",
       "8    8.901559  5.891057   7.772312  6.842025  7.240573   7.002783  11.110090   \n",
       "9    9.766315  6.566222   8.609722  7.745677  7.610556   7.689278  12.686389   \n",
       "10  10.550251  7.159910   9.387778  8.726308  8.347181   8.850376  14.155323   \n",
       "11  10.501130  7.134333  10.814861  8.427167  8.604000   8.943167  13.815741   \n",
       "12  11.301254  7.963710  11.849050  9.209355  9.447258   9.627670  14.259516   \n",
       "\n",
       "          MAL  \n",
       "Mo             \n",
       "1   18.028763  \n",
       "2   17.156142  \n",
       "3   16.909317  \n",
       "4   14.937611  \n",
       "5   13.736039  \n",
       "6   12.861818  \n",
       "7   12.800789  \n",
       "8   12.565943  \n",
       "9   14.761963  \n",
       "10  16.697151  \n",
       "11  18.114185  \n",
       "12  18.697599  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_mean = data.groupby(data.Mo).mean()\n",
    "data_mean "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Mo\n",
       "1     11.790920\n",
       "12    11.599800\n",
       "3     11.296313\n",
       "2     11.257743\n",
       "11    10.811319\n",
       "10    10.422061\n",
       "4     10.419079\n",
       "5      9.767791\n",
       "9      9.437308\n",
       "6      8.980183\n",
       "7      8.570066\n",
       "8      8.434918\n",
       "dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_mean.drop(columns = ['Yr', 'Dy']).mean(axis = 1). sort_values(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
